 CREATE  INDEX [IDX_NAME] ON [dbo].[TIGER_01](FENAME,ZIP3,FETYPE,ZIP,FEDIRP,FEDIRS)
GO
 CREATE  INDEX [IDX_TOLAT] ON [dbo].[TIGER_01]([TOLAT]) 
GO
 CREATE  INDEX [IDX_FRLAT] ON [dbo].[TIGER_01]([FRLAT]) 
GO
 CREATE  INDEX [IDX_T2_TLID] ON [dbo].[TIGER_02]([TLID]) 
GO
CREATE  INDEX [IX_FIPS55] ON [dbo].[FIPS55]([PLACE_NAME],[STATE_ALPHA] )
GO
